select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Pretty Apple Green Sweetheart Ball Gown Dresses For a Quinceanera
Beautiful Orange Ruffled Layers Ball Gown sweet 16 Quinceanera Dress
Ball Gown Dress for Quinces with Beading in Dark Green and Black
Fitted Multi-color Floor-length Quinces Dress with Beading
Appliques with Beading Sweet 15th Dress with Single Strap
Sweet 16th Dress with Beading and Appliques in Blue and Green
Coral Red and Black Quince Dress with Embroidery with Beading
Tulle Ruffles Sweet 16th Dress in Coral Red with Beading
Purple and White Sweet 16th Dress with Beading Decoration
White and Royal Blue Quinceanera Dresses with Embroidery
Beading and Pick-ups Quinceanera Dress in Hot Pink and White
Coral Red Quinceanera Gown with Beading and Sash in Taffeta
White and Green Sweetheart Quinces Dress with Embroidery
Strapless Purple Quinceanera Gown in Taffeta with Beading
Green Strapless Sweet 16th Dress with Beading in Taffeta
Purple and Fuchsia Quinceanera Gowns with Ruched Bodice
Sweet Sixteen Quinceanera Dresses with Sweetheart Neckline
Sweetheart Quinceanera Gowns with Ruffles and Embroidery
Lovely Light Blue Strapless Quinceanera Dress with Beaded Bust
Lavender Sweet 16 Sweetheart Quinceanera Dresses with Beading and Ruffles
Lovely Pink Ball Gown Quinceanera Dress with Beaded and Ruched Top
Green and Black Sweetheart Dress for Quince with Beads Encrusted on Top
Black and White Quinceanera Dress With Embroidery and Ruffles
Orange Sweetheart Appliques Quinceanera Dress with Ruffles
Royal Blue One Shoulder Quinceanera Dresses with Dripping Fabric
Apple Green A-line Strapless Floor-length Prom Dress with Flowers
Apple Green and Lavender Sweet 16 Dress by Organza with Sash and Ruches
Fuchsia and Blue A-line V-neck Sweet 15 Dresses with Handmade Flowers
Brown and White Quinceanera Dress by Taffeta and Tulle with Appliques
Multi-color Sweetheart Quinceanera Gown with Beaded Bust and Ruffles